Dataset statistics
| Number of variables | 45 |
|---|---|
| Number of observations | 170023 |
| Missing cells | 81976 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 57.2 MiB |
| Average record size in memory | 353.0 B |
Variable types
| CAT | 22 |
|---|---|
| NUM | 16 |
| BOOL | 7 |
Reproduction
| Analysis started | 2020-07-09 17:35:18.742143 |
|---|---|
| Analysis finished | 2020-07-09 17:36:43.297725 |
| Duration | 1 minute and 24.56 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
STREET_NAME has a high cardinality: 1341 distinct values | High cardinality |
BEAT_OF_OCCURRENCE has a high cardinality: 271 distinct values | High cardinality |
LONGITUDE is highly correlated with LATITUDE | High correlation |
LATITUDE is highly correlated with LONGITUDE | High correlation |
MAIN_CAUSE is highly correlated with PRIM_CONTRIBUTORY_CAUSE | High correlation |
PRIM_CONTRIBUTORY_CAUSE is highly correlated with MAIN_CAUSE | High correlation |
LANE_TYPE has 81976 (48.2%) missing values | Missing |
LATITUDE is highly skewed (γ1 = -94.06388966) | Skewed |
LONGITUDE is highly skewed (γ1 = 99.32443394) | Skewed |
df_index has unique values | Unique |
CRASH_RECORD_ID has unique values | Unique |
RD_NO has unique values | Unique |
POSTED_SPEED_LIMIT has 2351 (1.4%) zeros | Zeros |
INJURIES_TOTAL has 147605 (86.8%) zeros | Zeros |
INJURIES_INCAPACITATING has 167295 (98.4%) zeros | Zeros |
INJURIES_NON_INCAPACITATING has 157578 (92.7%) zeros | Zeros |
INJURIES_REPORTED_NOT_EVIDENT has 161617 (95.1%) zeros | Zeros |
INJURIES_NO_INDICATION has 2783 (1.6%) zeros | Zeros |
CRASH_HOUR has 2664 (1.6%) zeros | Zeros |
| Distinct count | 170023 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 212170.16976526706 |
|---|---|
| Minimum | 6 |
| Maximum | 416193 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 28454.4 |
| Q1 | 110251 |
| median | 212739 |
| Q3 | 314676.5 |
| 95-th percentile | 395658.8 |
| Maximum | 416193 |
| Range | 416187 |
| Interquartile range (IQR) | 204425.5 |
Descriptive statistics
| Standard deviation | 118096.4642 |
|---|---|
| Coefficient of variation (CV) | 0.5566120079 |
| Kurtosis | -1.191279946 |
| Mean | 212170.1698 |
| Median Absolute Deviation (MAD) | 102229 |
| Skewness | -0.01242153214 |
| Sum | 3.607380877e+10 |
| Variance | 1.394677486e+10 |
| Value | Count | Frequency (%) | |
| 264191 | 1 | < 0.1% | |
| 77199 | 1 | < 0.1% | |
| 69003 | 1 | < 0.1% | |
| 335241 | 1 | < 0.1% | |
| 71048 | 1 | < 0.1% | |
| 332436 | 1 | < 0.1% | |
| 353670 | 1 | < 0.1% | |
| 97669 | 1 | < 0.1% | |
| 95620 | 1 | < 0.1% | |
| 83330 | 1 | < 0.1% | |
| Other values (170013) | 170013 | > 99.9% |
| Value | Count | Frequency (%) | |
| 6 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 416193 | 1 | < 0.1% | |
| 416191 | 1 | < 0.1% | |
| 416187 | 1 | < 0.1% | |
| 416185 | 1 | < 0.1% | |
| 416184 | 1 | < 0.1% |
| Distinct count | 170023 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0369378756c36e5cf3e326082c410ed564f44eed3b2bdd7c4569fd5434c10c5cd8c9eff26cee6ac80f9323612c8b05635d411d6811c8d58f51a32905a84b1a8f | 1 |
|---|---|
| 65b898b3cd7fe07982a0961eafa7e15846934aab7bdefef1e4dd28223558766c75d54f743de04e9922a65205251a65cba98475c19b47728512f0ad6edac4b82d | 1 |
| b8308bbe775a21dc80a505c058af6c733a05c999500fb7778dfa6a1c69a8ddc45dff9b7bb930ac005dfade4ca520d9c32a55271d5c79d8da218d2eebe15d637f | 1 |
| 8d912c9ef59f64ac63e12b9ce41a50177a7e4d458c194ccdc15fcaab4477d4e88b221912ae9dbc9ced56fd55cebb2fd46e2a10b6169e6512b9c6af8eb7807c04 | 1 |
| 8cb5dac0a8f4c6fbfb22a00021e2464e192acbfb54596c3485d4c348e902c066d66b55dadee3dd2463c6f4b010ffdbec69f34270c67e56746ff37945bd5c4c89 | 1 |
| Other values (170018) |
| Value | Count | Frequency (%) | |
| 0369378756c36e5cf3e326082c410ed564f44eed3b2bdd7c4569fd5434c10c5cd8c9eff26cee6ac80f9323612c8b05635d411d6811c8d58f51a32905a84b1a8f | 1 | < 0.1% | |
| 65b898b3cd7fe07982a0961eafa7e15846934aab7bdefef1e4dd28223558766c75d54f743de04e9922a65205251a65cba98475c19b47728512f0ad6edac4b82d | 1 | < 0.1% | |
| b8308bbe775a21dc80a505c058af6c733a05c999500fb7778dfa6a1c69a8ddc45dff9b7bb930ac005dfade4ca520d9c32a55271d5c79d8da218d2eebe15d637f | 1 | < 0.1% | |
| 8d912c9ef59f64ac63e12b9ce41a50177a7e4d458c194ccdc15fcaab4477d4e88b221912ae9dbc9ced56fd55cebb2fd46e2a10b6169e6512b9c6af8eb7807c04 | 1 | < 0.1% | |
| 8cb5dac0a8f4c6fbfb22a00021e2464e192acbfb54596c3485d4c348e902c066d66b55dadee3dd2463c6f4b010ffdbec69f34270c67e56746ff37945bd5c4c89 | 1 | < 0.1% | |
| 2d2c0ab8950e029238e02e6ec4d8b83b614a557ee51bed49df04a1a364f060139a8b3c4ccd29599b71b0aeb54439f4e195b78b29ec3a3ac2c12e6beb784915c2 | 1 | < 0.1% | |
| e31dfcdb25c3d1a90b2fc9850a5f618601c6359fd1ebf915dcec0c36836ba0a09c926cf50fee2108c114c5bd0565e61ceed084f7192e2d9e21ebb66aff30531c | 1 | < 0.1% | |
| a2957d935da9b3c8d7a6d447d3d60ef747bc37fb61dc4f3feaa36378737d0877c9b84f6e1aa48f731725a14dfd3976a5d17907027230ee1a8e4d10ac906e3a11 | 1 | < 0.1% | |
| a22e6631f1f17fe980b99a82f5db0eccb3175c02f6eb27b86e4133757c7349763e8f2a7d9958b7a20b17e888d503139eda30544f1460a9d3cf049a28bf9d132a | 1 | < 0.1% | |
| fc93b7f28f4b387780c0c620734a58d168954d3208eceebc8d1c6d36616f796c864bbf35dabbca4341b90cc8e9feeef3b0d5d879b7a57749f916c8f52a0107ae | 1 | < 0.1% | |
| Other values (170013) | 170013 | > 99.9% |
Length
| Max length | 128 |
|---|---|
| Median length | 128 |
| Mean length | 128 |
| Min length | 128 |
| Distinct count | 170023 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| JC565912 | 1 |
|---|---|
| JC428556 | 1 |
| JA398424 | 1 |
| JC174948 | 1 |
| JB550813 | 1 |
| Other values (170018) |
| Value | Count | Frequency (%) | |
| JC565912 | 1 | < 0.1% | |
| JC428556 | 1 | < 0.1% | |
| JA398424 | 1 | < 0.1% | |
| JC174948 | 1 | < 0.1% | |
| JB550813 | 1 | < 0.1% | |
| JA536780 | 1 | < 0.1% | |
| JC236142 | 1 | < 0.1% | |
| JC263315 | 1 | < 0.1% | |
| JC553659 | 1 | < 0.1% | |
| HZ548179 | 1 | < 0.1% | |
| Other values (170013) | 170013 | > 99.9% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.67997270957459 |
|---|---|
| Minimum | 0.0 |
| Maximum | 70.0 |
| Zeros | 2351 |
| Zeros (%) | 1.4% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 30 |
| median | 30 |
| Q3 | 30 |
| 95-th percentile | 35 |
| Maximum | 70 |
| Range | 70 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.125015883 |
|---|---|
| Coefficient of variation (CV) | 0.2135642159 |
| Kurtosis | 8.292285248 |
| Mean | 28.67997271 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.307732956 |
| Sum | 4876255 |
| Variance | 37.51581957 |
| Value | Count | Frequency (%) | |
| 30 | 129139 | 76.0% | |
| 35 | 12097 | 7.1% | |
| 25 | 8767 | 5.2% | |
| 20 | 5400 | 3.2% | |
| 15 | 5217 | 3.1% | |
| 10 | 2586 | 1.5% | |
| 0 | 2351 | 1.4% | |
| 40 | 1930 | 1.1% | |
| 45 | 1212 | 0.7% | |
| 5 | 1141 | 0.7% | |
| Other values (4) | 183 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 2351 | 1.4% | |
| 5 | 1141 | 0.7% | |
| 10 | 2586 | 1.5% | |
| 15 | 5217 | 3.1% | |
| 20 | 5400 | 3.2% |
| Value | Count | Frequency (%) | |
| 70 | 1 | < 0.1% | |
| 60 | 10 | < 0.1% | |
| 55 | 137 | 0.1% | |
| 50 | 35 | < 0.1% | |
| 45 | 1212 | 0.7% |
TRAFFIC_CONTROL_DEVICE
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| NO CONTROLS | |
|---|---|
| TRAFFIC SIGNAL | |
| STOP SIGN/FLASHER | |
| UNKNOWN | 3110 |
| OTHER | 1026 |
| Other values (14) | 1876 |
| Value | Count | Frequency (%) | |
| NO CONTROLS | 88229 | 51.9% | |
| TRAFFIC SIGNAL | 55468 | 32.6% | |
| STOP SIGN/FLASHER | 20314 | 11.9% | |
| UNKNOWN | 3110 | 1.8% | |
| OTHER | 1026 | 0.6% | |
| LANE USE MARKING | 629 | 0.4% | |
| YIELD | 309 | 0.2% | |
| OTHER WARNING SIGN | 218 | 0.1% | |
| OTHER REG. SIGN | 210 | 0.1% | |
| RAILROAD CROSSING GATE | 135 | 0.1% | |
| Other values (9) | 375 | 0.2% |
Length
| Max length | 24 |
|---|---|
| Median length | 11 |
| Mean length | 12.62965011 |
| Min length | 5 |
DEVICE_CONDITION
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| NO CONTROLS | |
|---|---|
| FUNCTIONING PROPERLY | |
| UNKNOWN | 6243 |
| OTHER | 1360 |
| FUNCTIONING IMPROPERLY | 1117 |
| Other values (3) | 696 |
| Value | Count | Frequency (%) | |
| NO CONTROLS | 89998 | 52.9% | |
| FUNCTIONING PROPERLY | 70609 | 41.5% | |
| UNKNOWN | 6243 | 3.7% | |
| OTHER | 1360 | 0.8% | |
| FUNCTIONING IMPROPERLY | 1117 | 0.7% | |
| NOT FUNCTIONING | 553 | 0.3% | |
| WORN REFLECTIVE MATERIAL | 114 | 0.1% | |
| MISSING | 29 | < 0.1% |
Length
| Max length | 24 |
|---|---|
| Median length | 11 |
| Mean length | 14.636061 |
| Min length | 5 |
WEATHER_CONDITION
Categorical
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| CLEAR | |
|---|---|
| RAIN | 17503 |
| SNOW | 7254 |
| CLOUDY/OVERCAST | 6135 |
| UNKNOWN | 2174 |
| Other values (6) | 1444 |
| Value | Count | Frequency (%) | |
| CLEAR | 135513 | 79.7% | |
| RAIN | 17503 | 10.3% | |
| SNOW | 7254 | 4.3% | |
| CLOUDY/OVERCAST | 6135 | 3.6% | |
| UNKNOWN | 2174 | 1.3% | |
| OTHER | 559 | 0.3% | |
| FOG/SMOKE/HAZE | 353 | 0.2% | |
| SLEET/HAIL | 306 | 0.2% | |
| FREEZING RAIN/DRIZZLE | 156 | 0.1% | |
| SEVERE CROSS WIND GATE | 46 | < 0.1% |
Length
| Max length | 22 |
|---|---|
| Median length | 5 |
| Mean length | 5.288749169 |
| Min length | 4 |
LIGHTING_CONDITION
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| DAYLIGHT | |
|---|---|
| DARKNESS, LIGHTED ROAD | |
| DARKNESS | 7452 |
| DUSK | 5267 |
| DAWN | 2971 |
| Value | Count | Frequency (%) | |
| DAYLIGHT | 117230 | 68.9% | |
| DARKNESS, LIGHTED ROAD | 35379 | 20.8% | |
| DARKNESS | 7452 | 4.4% | |
| DUSK | 5267 | 3.1% | |
| DAWN | 2971 | 1.7% | |
| UNKNOWN | 1724 | 1.0% |
Length
| Max length | 22 |
|---|---|
| Median length | 8 |
| Mean length | 10.70922169 |
| Min length | 4 |
FIRST_CRASH_TYPE
Categorical
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| REAR END | |
|---|---|
| SIDESWIPE SAME DIRECTION | |
| TURNING | |
| PARKED MOTOR VEHICLE | |
| ANGLE | |
| Other values (13) |
| Value | Count | Frequency (%) | |
| REAR END | 52403 | 30.8% | |
| SIDESWIPE SAME DIRECTION | 31505 | 18.5% | |
| TURNING | 23259 | 13.7% | |
| PARKED MOTOR VEHICLE | 22195 | 13.1% | |
| ANGLE | 22150 | 13.0% | |
| FIXED OBJECT | 5461 | 3.2% | |
| PEDESTRIAN | 3566 | 2.1% | |
| SIDESWIPE OPPOSITE DIRECTION | 2569 | 1.5% | |
| PEDALCYCLIST | 2214 | 1.3% | |
| HEAD ON | 1613 | 0.9% | |
| Other values (8) | 3088 | 1.8% |
Length
| Max length | 28 |
|---|---|
| Median length | 8 |
| Mean length | 12.60164801 |
| Min length | 5 |
TRAFFICWAY_TYPE
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| NOT DIVIDED | |
|---|---|
| DIVIDED - W/MEDIAN (NOT RAISED) | |
| ONE-WAY | |
| DIVIDED - W/MEDIAN BARRIER | 12003 |
| PARKING LOT | 9926 |
| Other values (15) |
| Value | Count | Frequency (%) | |
| NOT DIVIDED | 76991 | 45.3% | |
| DIVIDED - W/MEDIAN (NOT RAISED) | 35361 | 20.8% | |
| ONE-WAY | 19075 | 11.2% | |
| DIVIDED - W/MEDIAN BARRIER | 12003 | 7.1% | |
| PARKING LOT | 9926 | 5.8% | |
| OTHER | 4906 | 2.9% | |
| FOUR WAY | 4051 | 2.4% | |
| ALLEY | 2268 | 1.3% | |
| CENTER TURN LANE | 1733 | 1.0% | |
| UNKNOWN | 1092 | 0.6% | |
| Other values (10) | 2617 | 1.5% |
Length
| Max length | 31 |
|---|---|
| Median length | 11 |
| Mean length | 15.47732366 |
| Min length | 4 |
ROADWAY_SURFACE_COND
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| DRY | |
|---|---|
| WET | |
| SNOW OR SLUSH | 6743 |
| UNKNOWN | 5774 |
| ICE | 1689 |
| Other values (2) | 424 |
| Value | Count | Frequency (%) | |
| DRY | 128493 | 75.6% | |
| WET | 26900 | 15.8% | |
| SNOW OR SLUSH | 6743 | 4.0% | |
| UNKNOWN | 5774 | 3.4% | |
| ICE | 1689 | 1.0% | |
| OTHER | 335 | 0.2% | |
| SAND, MUD, DIRT | 89 | 0.1% |
Length
| Max length | 15 |
|---|---|
| Median length | 3 |
| Mean length | 3.542655994 |
| Min length | 3 |
ROAD_DEFECT
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| NO DEFECTS | |
|---|---|
| UNKNOWN | 20131 |
| RUT, HOLES | 1242 |
| OTHER | 1052 |
| WORN SURFACE | 706 |
| Other values (2) | 567 |
| Value | Count | Frequency (%) | |
| NO DEFECTS | 146325 | 86.1% | |
| UNKNOWN | 20131 | 11.8% | |
| RUT, HOLES | 1242 | 0.7% | |
| OTHER | 1052 | 0.6% | |
| WORN SURFACE | 706 | 0.4% | |
| SHOULDER DEFECT | 400 | 0.2% | |
| DEBRIS ON ROADWAY | 167 | 0.1% |
Length
| Max length | 17 |
|---|---|
| Median length | 10 |
| Mean length | 9.640801539 |
| Min length | 5 |
REPORT_TYPE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| NOT ON SCENE (DESK REPORT) | |
|---|---|
| ON SCENE |
| Value | Count | Frequency (%) | |
| NOT ON SCENE (DESK REPORT) | 98971 | 58.2% | |
| ON SCENE | 71052 | 41.8% |
Length
| Max length | 26 |
|---|---|
| Median length | 26 |
| Mean length | 18.47786476 |
| Min length | 8 |
CRASH_TYPE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| NO INJURY / DRIVE AWAY | |
|---|---|
| INJURY AND / OR TOW DUE TO CRASH |
| Value | Count | Frequency (%) | |
| NO INJURY / DRIVE AWAY | 127310 | 74.9% | |
| INJURY AND / OR TOW DUE TO CRASH | 42713 | 25.1% |
Length
| Max length | 32 |
|---|---|
| Median length | 22 |
| Mean length | 24.51218953 |
| Min length | 22 |
HIT_AND_RUN_I
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 135422 | 79.6% | |
| 1 | 34601 | 20.4% |
DAMAGE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| OVER $1,500 | |
|---|---|
| $501 - $1,500 | |
| $500 OR LESS |
| Value | Count | Frequency (%) | |
| OVER $1,500 | 99753 | 58.7% | |
| $501 - $1,500 | 48427 | 28.5% | |
| $500 OR LESS | 21843 | 12.8% |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 11.6981232 |
| Min length | 11 |
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| FOLLOWING TOO CLOSELY | |
|---|---|
| FAILING TO YIELD RIGHT-OF-WAY | |
| IMPROPER OVERTAKING/PASSING | |
| IMPROPER BACKING | |
| IMPROPER LANE USAGE | |
| Other values (28) |
| Value | Count | Frequency (%) | |
| FOLLOWING TOO CLOSELY | 36010 | 21.2% | |
| FAILING TO YIELD RIGHT-OF-WAY | 35339 | 20.8% | |
| IMPROPER OVERTAKING/PASSING | 15747 | 9.3% | |
| IMPROPER BACKING | 14179 | 8.3% | |
| IMPROPER LANE USAGE | 12920 | 7.6% | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 12487 | 7.3% | |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 9678 | 5.7% | |
| WEATHER | 5003 | 2.9% | |
| DISREGARDING TRAFFIC SIGNALS | 4822 | 2.8% | |
| DISREGARDING STOP SIGN | 3170 | 1.9% | |
| Other values (23) | 20668 | 12.2% |
Length
| Max length | 80 |
|---|---|
| Median length | 27 |
| Mean length | 27.14715068 |
| Min length | 6 |
SEC_CONTRIBUTORY_CAUSE
Categorical
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| NOT APPLICABLE | |
|---|---|
| UNABLE TO DETERMINE | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 12053 |
| FOLLOWING TOO CLOSELY | 8748 |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 8659 |
| Other values (35) |
| Value | Count | Frequency (%) | |
| NOT APPLICABLE | 64854 | 38.1% | |
| UNABLE TO DETERMINE | 38816 | 22.8% | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 12053 | 7.1% | |
| FOLLOWING TOO CLOSELY | 8748 | 5.1% | |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 8659 | 5.1% | |
| FAILING TO YIELD RIGHT-OF-WAY | 8461 | 5.0% | |
| IMPROPER OVERTAKING/PASSING | 4279 | 2.5% | |
| IMPROPER LANE USAGE | 3873 | 2.3% | |
| WEATHER | 3578 | 2.1% | |
| IMPROPER BACKING | 2615 | 1.5% | |
| Other values (30) | 14087 | 8.3% |
Length
| Max length | 80 |
|---|---|
| Median length | 19 |
| Mean length | 21.33806603 |
| Min length | 6 |
STREET_NO
Real number (ℝ≥0)
| Distinct count | 9237 |
|---|---|
| Unique (%) | 5.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3569.368708939379 |
|---|---|
| Minimum | 1.0 |
| Maximum | 13799.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 128 |
| Q1 | 1158 |
| median | 3100 |
| Q3 | 5500 |
| 95-th percentile | 8700 |
| Maximum | 13799 |
| Range | 13798 |
| Interquartile range (IQR) | 4342 |
Descriptive statistics
| Standard deviation | 2810.179625 |
|---|---|
| Coefficient of variation (CV) | 0.7873043817 |
| Kurtosis | 0.004114620722 |
| Mean | 3569.368709 |
| Median Absolute Deviation (MAD) | 2120 |
| Skewness | 0.7582665448 |
| Sum | 606874776 |
| Variance | 7897109.522 |
| Value | Count | Frequency (%) | |
| 100 | 1282 | 0.8% | |
| 1600 | 1125 | 0.7% | |
| 200 | 1077 | 0.6% | |
| 300 | 1073 | 0.6% | |
| 800 | 1065 | 0.6% | |
| 500 | 1005 | 0.6% | |
| 2400 | 925 | 0.5% | |
| 600 | 905 | 0.5% | |
| 1200 | 890 | 0.5% | |
| 6300 | 884 | 0.5% | |
| Other values (9227) | 159792 | 94.0% |
| Value | Count | Frequency (%) | |
| 1 | 635 | 0.4% | |
| 2 | 349 | 0.2% | |
| 3 | 64 | < 0.1% | |
| 4 | 40 | < 0.1% | |
| 5 | 93 | 0.1% |
| Value | Count | Frequency (%) | |
| 13799 | 1 | < 0.1% | |
| 13770 | 5 | < 0.1% | |
| 13758 | 1 | < 0.1% | |
| 13756 | 1 | < 0.1% | |
| 13755 | 1 | < 0.1% |
STREET_DIRECTION
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| W | |
|---|---|
| S | |
| N | |
| E | 11381 |
| Value | Count | Frequency (%) | |
| W | 61742 | 36.3% | |
| S | 54254 | 31.9% | |
| N | 42646 | 25.1% | |
| E | 11381 | 6.7% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 1341 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| WESTERN AVE | 4876 |
|---|---|
| PULASKI RD | 4295 |
| CICERO AVE | 4041 |
| ASHLAND AVE | 3806 |
| HALSTED ST | 3500 |
| Other values (1336) |
| Value | Count | Frequency (%) | |
| WESTERN AVE | 4876 | 2.9% | |
| PULASKI RD | 4295 | 2.5% | |
| CICERO AVE | 4041 | 2.4% | |
| ASHLAND AVE | 3806 | 2.2% | |
| HALSTED ST | 3500 | 2.1% | |
| KEDZIE AVE | 2884 | 1.7% | |
| MICHIGAN AVE | 2549 | 1.5% | |
| STATE ST | 2283 | 1.3% | |
| CLARK ST | 2241 | 1.3% | |
| NORTH AVE | 2125 | 1.2% | |
| Other values (1331) | 137423 | 80.8% |
Length
| Max length | 27 |
|---|---|
| Median length | 10 |
| Mean length | 10.69305329 |
| Min length | 5 |
| Distinct count | 271 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1834.0 | 2490 |
|---|---|
| 114.0 | 2363 |
| 122.0 | 2273 |
| 1831.0 | 1869 |
| 813.0 | 1690 |
| Other values (266) |
| Value | Count | Frequency (%) | |
| 1834.0 | 2490 | 1.5% | |
| 114.0 | 2363 | 1.4% | |
| 122.0 | 2273 | 1.3% | |
| 1831.0 | 1869 | 1.1% | |
| 813.0 | 1690 | 1.0% | |
| 815.0 | 1681 | 1.0% | |
| 2512.0 | 1424 | 0.8% | |
| 1622.0 | 1421 | 0.8% | |
| 833.0 | 1414 | 0.8% | |
| 834.0 | 1374 | 0.8% | |
| Other values (261) | 152024 | 89.4% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.593560871 |
| Min length | 5 |
NUM_UNITS
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0433000241143846 |
|---|---|
| Minimum | 1.0 |
| Maximum | 12.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3995417469 |
|---|---|
| Coefficient of variation (CV) | 0.1955374846 |
| Kurtosis | 33.41500969 |
| Mean | 2.043300024 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.370232641 |
| Sum | 347408 |
| Variance | 0.1596336075 |
| Value | Count | Frequency (%) | |
| 2 | 152537 | 89.7% | |
| 3 | 9182 | 5.4% | |
| 1 | 6367 | 3.7% | |
| 4 | 1491 | 0.9% | |
| 5 | 313 | 0.2% | |
| 6 | 85 | < 0.1% | |
| 7 | 21 | < 0.1% | |
| 8 | 16 | < 0.1% | |
| 9 | 7 | < 0.1% | |
| 11 | 2 | < 0.1% | |
| Other values (2) | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 6367 | 3.7% | |
| 2 | 152537 | 89.7% | |
| 3 | 9182 | 5.4% | |
| 4 | 1491 | 0.9% | |
| 5 | 313 | 0.2% |
| Value | Count | Frequency (%) | |
| 12 | 1 | < 0.1% | |
| 11 | 2 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 9 | 7 | < 0.1% | |
| 8 | 16 | < 0.1% |
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.17885227292778036 |
|---|---|
| Minimum | 0.0 |
| Maximum | 13.0 |
| Zeros | 147605 |
| Zeros (%) | 86.8% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5395852213 |
|---|---|
| Coefficient of variation (CV) | 3.016932424 |
| Kurtosis | 31.08309577 |
| Mean | 0.1788522729 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.473596523 |
| Sum | 30409 |
| Variance | 0.2911522111 |
| Value | Count | Frequency (%) | |
| 0 | 147605 | 86.8% | |
| 1 | 17063 | 10.0% | |
| 2 | 3679 | 2.2% | |
| 3 | 1096 | 0.6% | |
| 4 | 357 | 0.2% | |
| 5 | 138 | 0.1% | |
| 6 | 47 | < 0.1% | |
| 7 | 22 | < 0.1% | |
| 8 | 8 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| Other values (3) | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 147605 | 86.8% | |
| 1 | 17063 | 10.0% | |
| 2 | 3679 | 2.2% | |
| 3 | 1096 | 0.6% | |
| 4 | 357 | 0.2% |
| Value | Count | Frequency (%) | |
| 13 | 1 | < 0.1% | |
| 11 | 2 | < 0.1% | |
| 10 | 2 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| 8 | 8 | < 0.1% |
INJURIES_FATAL
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| 1 | 82 |
| 2 | 4 |
| 3 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 169936 | 99.9% | |
| 1 | 82 | < 0.1% | |
| 2 | 4 | < 0.1% | |
| 3 | 1 | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.018891561729883603 |
|---|---|
| Minimum | 0.0 |
| Maximum | 5.0 |
| Zeros | 167295 |
| Zeros (%) | 98.4% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1619503063 |
|---|---|
| Coefficient of variation (CV) | 8.572626689 |
| Kurtosis | 173.3193565 |
| Mean | 0.01889156173 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.30760395 |
| Sum | 3212 |
| Variance | 0.02622790171 |
| Value | Count | Frequency (%) | |
| 0 | 167295 | 98.4% | |
| 1 | 2375 | 1.4% | |
| 2 | 256 | 0.2% | |
| 3 | 68 | < 0.1% | |
| 4 | 24 | < 0.1% | |
| 5 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 167295 | 98.4% | |
| 1 | 2375 | 1.4% | |
| 2 | 256 | 0.2% | |
| 3 | 68 | < 0.1% | |
| 4 | 24 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 5 | < 0.1% | |
| 4 | 24 | < 0.1% | |
| 3 | 68 | < 0.1% | |
| 2 | 256 | 0.2% | |
| 1 | 2375 | 1.4% |
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09533416067237963 |
|---|---|
| Minimum | 0.0 |
| Maximum | 11.0 |
| Zeros | 157578 |
| Zeros (%) | 92.7% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3921160241 |
|---|---|
| Coefficient of variation (CV) | 4.113069453 |
| Kurtosis | 58.02302948 |
| Mean | 0.09533416067 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.119044588 |
| Sum | 16209 |
| Variance | 0.1537549764 |
| Value | Count | Frequency (%) | |
| 0 | 157578 | 92.7% | |
| 1 | 9906 | 5.8% | |
| 2 | 1758 | 1.0% | |
| 3 | 507 | 0.3% | |
| 4 | 177 | 0.1% | |
| 5 | 57 | < 0.1% | |
| 6 | 22 | < 0.1% | |
| 7 | 11 | < 0.1% | |
| 8 | 4 | < 0.1% | |
| 11 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 157578 | 92.7% | |
| 1 | 9906 | 5.8% | |
| 2 | 1758 | 1.0% | |
| 3 | 507 | 0.3% | |
| 4 | 177 | 0.1% |
| Value | Count | Frequency (%) | |
| 11 | 2 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 8 | 4 | < 0.1% | |
| 7 | 11 | < 0.1% | |
| 6 | 22 | < 0.1% |
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06407956570581627 |
|---|---|
| Minimum | 0.0 |
| Maximum | 10.0 |
| Zeros | 161617 |
| Zeros (%) | 95.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3201525205 |
|---|---|
| Coefficient of variation (CV) | 4.996171821 |
| Kurtosis | 75.43556623 |
| Mean | 0.06407956571 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.137627663 |
| Sum | 10895 |
| Variance | 0.1024976364 |
| Value | Count | Frequency (%) | |
| 0 | 161617 | 95.1% | |
| 1 | 6647 | 3.9% | |
| 2 | 1275 | 0.7% | |
| 3 | 330 | 0.2% | |
| 4 | 94 | 0.1% | |
| 5 | 43 | < 0.1% | |
| 6 | 9 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 161617 | 95.1% | |
| 1 | 6647 | 3.9% | |
| 2 | 1275 | 0.7% | |
| 3 | 330 | 0.2% | |
| 4 | 94 | 0.1% |
| Value | Count | Frequency (%) | |
| 10 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 6 | 9 | < 0.1% |
| Distinct count | 19 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1724119677925926 |
|---|---|
| Minimum | 0.0 |
| Maximum | 19.0 |
| Zeros | 2783 |
| Zeros (%) | 1.6% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.107867356 |
|---|---|
| Coefficient of variation (CV) | 0.5099711163 |
| Kurtosis | 10.11862197 |
| Mean | 2.172411968 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.054233066 |
| Sum | 369360 |
| Variance | 1.227370079 |
| Value | Count | Frequency (%) | |
| 2 | 92726 | 54.5% | |
| 1 | 33734 | 19.8% | |
| 3 | 24807 | 14.6% | |
| 4 | 9305 | 5.5% | |
| 5 | 3846 | 2.3% | |
| 0 | 2783 | 1.6% | |
| 6 | 1641 | 1.0% | |
| 7 | 640 | 0.4% | |
| 8 | 280 | 0.2% | |
| 9 | 118 | 0.1% | |
| Other values (9) | 143 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 2783 | 1.6% | |
| 1 | 33734 | 19.8% | |
| 2 | 92726 | 54.5% | |
| 3 | 24807 | 14.6% | |
| 4 | 9305 | 5.5% |
| Value | Count | Frequency (%) | |
| 19 | 1 | < 0.1% | |
| 17 | 4 | < 0.1% | |
| 16 | 8 | < 0.1% | |
| 15 | 4 | < 0.1% | |
| 14 | 12 | < 0.1% |
| Distinct count | 24 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.280756132993771 |
|---|---|
| Minimum | 0.0 |
| Maximum | 23.0 |
| Zeros | 2664 |
| Zeros (%) | 1.6% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 9 |
| median | 14 |
| Q3 | 17 |
| 95-th percentile | 21 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.257633647 |
|---|---|
| Coefficient of variation (CV) | 0.3958836074 |
| Kurtosis | -0.347998741 |
| Mean | 13.28075613 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.3704724486 |
| Sum | 2258034 |
| Variance | 27.64271157 |
| Value | Count | Frequency (%) | |
| 16 | 13622 | 8.0% | |
| 15 | 13502 | 7.9% | |
| 17 | 13247 | 7.8% | |
| 14 | 11804 | 6.9% | |
| 18 | 10641 | 6.3% | |
| 13 | 10495 | 6.2% | |
| 8 | 10445 | 6.1% | |
| 12 | 9932 | 5.8% | |
| 11 | 8779 | 5.2% | |
| 7 | 8503 | 5.0% | |
| Other values (14) | 59053 | 34.7% |
| Value | Count | Frequency (%) | |
| 0 | 2664 | 1.6% | |
| 1 | 2148 | 1.3% | |
| 2 | 1932 | 1.1% | |
| 3 | 1563 | 0.9% | |
| 4 | 1490 | 0.9% |
| Value | Count | Frequency (%) | |
| 23 | 3747 | 2.2% | |
| 22 | 4585 | 2.7% | |
| 21 | 5116 | 3.0% | |
| 20 | 5854 | 3.4% | |
| 19 | 7477 | 4.4% |
CRASH_DAY_OF_WEEK
Real number (ℝ≥0)
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.143574692835675 |
|---|---|
| Minimum | 1.0 |
| Maximum | 7.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.943718512 |
|---|---|
| Coefficient of variation (CV) | 0.4690921864 |
| Kurtosis | -1.20505114 |
| Mean | 4.143574693 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.08342100232 |
| Sum | 704503 |
| Variance | 3.778041654 |
| Value | Count | Frequency (%) | |
| 6 | 28091 | 16.5% | |
| 5 | 25247 | 14.8% | |
| 4 | 24911 | 14.7% | |
| 3 | 24904 | 14.6% | |
| 7 | 24133 | 14.2% | |
| 2 | 23698 | 13.9% | |
| 1 | 19039 | 11.2% |
| Value | Count | Frequency (%) | |
| 1 | 19039 | 11.2% | |
| 2 | 23698 | 13.9% | |
| 3 | 24904 | 14.6% | |
| 4 | 24911 | 14.7% | |
| 5 | 25247 | 14.8% |
| Value | Count | Frequency (%) | |
| 7 | 24133 | 14.2% | |
| 6 | 28091 | 16.5% | |
| 5 | 25247 | 14.8% | |
| 4 | 24911 | 14.7% | |
| 3 | 24904 | 14.6% |
CRASH_MONTH
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.630979338089553 |
|---|---|
| Minimum | 1.0 |
| Maximum | 12.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.497311421 |
|---|---|
| Coefficient of variation (CV) | 0.527420045 |
| Kurtosis | -1.249054291 |
| Mean | 6.630979338 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.04830946728 |
| Sum | 1127419 |
| Variance | 12.23118717 |
| Value | Count | Frequency (%) | |
| 10 | 15814 | 9.3% | |
| 12 | 15531 | 9.1% | |
| 11 | 15050 | 8.9% | |
| 5 | 14807 | 8.7% | |
| 9 | 14395 | 8.5% | |
| 1 | 14149 | 8.3% | |
| 3 | 13782 | 8.1% | |
| 6 | 13712 | 8.1% | |
| 8 | 13616 | 8.0% | |
| 2 | 13602 | 8.0% | |
| Other values (2) | 25565 | 15.0% |
| Value | Count | Frequency (%) | |
| 1 | 14149 | 8.3% | |
| 2 | 13602 | 8.0% | |
| 3 | 13782 | 8.1% | |
| 4 | 13029 | 7.7% | |
| 5 | 14807 | 8.7% |
| Value | Count | Frequency (%) | |
| 12 | 15531 | 9.1% | |
| 11 | 15050 | 8.9% | |
| 10 | 15814 | 9.3% | |
| 9 | 14395 | 8.5% | |
| 8 | 13616 | 8.0% |
| Distinct count | 93791 |
|---|---|
| Unique (%) | 55.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.85832423734304 |
|---|---|
| Minimum | 0.0 |
| Maximum | 42.022779861 |
| Zeros | 17 |
| Zeros (%) | < 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 41.71524485 |
| Q1 | 41.78958119 |
| median | 41.87944196 |
| Q3 | 41.92768648 |
| 95-th percentile | 41.99054486 |
| Maximum | 42.02277986 |
| Range | 42.02277986 |
| Interquartile range (IQR) | 0.138105291 |
Descriptive statistics
| Standard deviation | 0.4271946112 |
|---|---|
| Coefficient of variation (CV) | 0.01020572656 |
| Kurtosis | 9213.872316 |
| Mean | 41.85832424 |
| Median Absolute Deviation (MAD) | 0.066371257 |
| Skewness | -94.06388966 |
| Sum | 7116877.862 |
| Variance | 0.1824952359 |
| Value | Count | Frequency (%) | |
| 41.97620114 | 212 | 0.1% | |
| 41.7514606 | 112 | 0.1% | |
| 41.90095892 | 108 | 0.1% | |
| 41.79142028 | 107 | 0.1% | |
| 41.72225727 | 85 | < 0.1% | |
| 41.90100286 | 74 | < 0.1% | |
| 41.78932932 | 74 | < 0.1% | |
| 41.75466012 | 70 | < 0.1% | |
| 41.73620947 | 67 | < 0.1% | |
| 41.79291088 | 65 | < 0.1% | |
| Other values (93781) | 169049 | 99.4% |
| Value | Count | Frequency (%) | |
| 0 | 17 | < 0.1% | |
| 41.64467013 | 4 | < 0.1% | |
| 41.64469397 | 2 | < 0.1% | |
| 41.64471544 | 1 | < 0.1% | |
| 41.64471877 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 42.02277986 | 2 | < 0.1% | |
| 42.02266114 | 2 | < 0.1% | |
| 42.02264514 | 1 | < 0.1% | |
| 42.02264168 | 1 | < 0.1% | |
| 42.02255132 | 1 | < 0.1% |
| Distinct count | 93787 |
|---|---|
| Unique (%) | 55.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -87.67070524713213 |
|---|---|
| Minimum | -87.934014222 |
| Maximum | 0.0 |
| Zeros | 17 |
| Zeros (%) | < 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -87.93401422 |
|---|---|
| 5-th percentile | -87.78188205 |
| Q1 | -87.72230714 |
| median | -87.67272966 |
| Q3 | -87.63315544 |
| 95-th percentile | -87.58762602 |
| Maximum | 0 |
| Range | 87.93401422 |
| Interquartile range (IQR) | 0.089151695 |
Descriptive statistics
| Standard deviation | 0.8786550779 |
|---|---|
| Coefficient of variation (CV) | -0.0100222198 |
| Kurtosis | 9907.679574 |
| Mean | -87.67070525 |
| Median Absolute Deviation (MAD) | 0.042582218 |
| Skewness | 99.32443394 |
| Sum | -14906036.32 |
| Variance | 0.7720347459 |
| Value | Count | Frequency (%) | |
| -87.90530913 | 212 | 0.1% | |
| -87.58597199 | 112 | 0.1% | |
| -87.61992817 | 108 | 0.1% | |
| -87.58014777 | 107 | 0.1% | |
| -87.58527557 | 85 | < 0.1% | |
| -87.74164564 | 74 | < 0.1% | |
| -87.61977981 | 74 | < 0.1% | |
| -87.74138476 | 70 | < 0.1% | |
| -87.62430552 | 67 | < 0.1% | |
| -87.74207734 | 65 | < 0.1% | |
| Other values (93777) | 169049 | 99.4% |
| Value | Count | Frequency (%) | |
| -87.93401422 | 1 | < 0.1% | |
| -87.93399393 | 10 | < 0.1% | |
| -87.93302828 | 2 | < 0.1% | |
| -87.92726168 | 2 | < 0.1% | |
| -87.92503562 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 17 | < 0.1% | |
| -87.52458739 | 1 | < 0.1% | |
| -87.52458901 | 1 | < 0.1% | |
| -87.52464032 | 1 | < 0.1% | |
| -87.52467395 | 2 | < 0.1% |
STREET_TYPE
Categorical
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| AVE | |
|---|---|
| ST | |
| RD | 11639 |
| DR | 6561 |
| BLVD | 6163 |
| Other values (10) | 8474 |
| Value | Count | Frequency (%) | |
| AVE | 85561 | 50.3% | |
| ST | 51625 | 30.4% | |
| RD | 11639 | 6.8% | |
| DR | 6561 | 3.9% | |
| BLVD | 6163 | 3.6% | |
| NB | 1556 | 0.9% | |
| SB | 1484 | 0.9% | |
| PL | 1300 | 0.8% | |
| PKWY | 1202 | 0.7% | |
| BROADWAY | 933 | 0.5% | |
| Other values (5) | 1999 | 1.2% |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 2.631173429 |
| Min length | 1 |
TRAFFIC_CONTROL_PRESENT
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 88229 | 51.9% | |
| 1 | 81794 | 48.1% |
STRAIGHT_ROAD
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1 | |
|---|---|
| 0 | 1789 |
| Value | Count | Frequency (%) | |
| 1 | 168234 | 98.9% | |
| 0 | 1789 | 1.1% |
LEVEL_ROAD
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1 | |
|---|---|
| 0 | 3345 |
| Value | Count | Frequency (%) | |
| 1 | 166678 | 98.0% | |
| 0 | 3345 | 2.0% |
TIME_BEFORE_NOTIFICATION
Real number (ℝ≥0)
| Distinct count | 1179 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 93.18010504461161 |
|---|---|
| Minimum | 2.0000000000000004 |
| Maximum | 1182.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 9 |
| median | 28 |
| Q3 | 69 |
| 95-th percentile | 550 |
| Maximum | 1182 |
| Range | 1180 |
| Interquartile range (IQR) | 60 |
Descriptive statistics
| Standard deviation | 196.7186373 |
|---|---|
| Coefficient of variation (CV) | 2.111165652 |
| Kurtosis | 12.82761221 |
| Mean | 93.18010504 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 3.551872939 |
| Sum | 15842761 |
| Variance | 38698.22225 |
| Value | Count | Frequency (%) | |
| 5 | 12259 | 7.2% | |
| 2 | 8899 | 5.2% | |
| 10 | 7590 | 4.5% | |
| 30 | 7510 | 4.4% | |
| 15 | 7273 | 4.3% | |
| 3 | 6682 | 3.9% | |
| 20 | 6100 | 3.6% | |
| 4 | 5490 | 3.2% | |
| 25 | 4225 | 2.5% | |
| 60 | 3868 | 2.3% | |
| Other values (1169) | 100127 | 58.9% |
| Value | Count | Frequency (%) | |
| 2 | 8899 | 5.2% | |
| 3 | 6682 | 3.9% | |
| 4 | 5490 | 3.2% | |
| 5 | 12259 | 7.2% | |
| 6 | 3634 | 2.1% |
| Value | Count | Frequency (%) | |
| 1182 | 8 | < 0.1% | |
| 1181 | 5 | < 0.1% | |
| 1180 | 52 | < 0.1% | |
| 1179 | 1 | < 0.1% | |
| 1178 | 9 | < 0.1% |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 81976 |
| Missing (%) | 48.2% |
| Memory size | 166.2 KiB |
| small | |
|---|---|
| medium | |
| large | 3538 |
| intersection | 3469 |
| Value | Count | Frequency (%) | |
| small | 51328 | 30.2% | |
| medium | 29712 | 17.5% | |
| large | 3538 | 2.1% | |
| intersection | 3469 | 2.0% | |
| (Missing) | 81976 | 48.2% |
Length
| Max length | 12 |
|---|---|
| Median length | 5 |
| Mean length | 4.353281615 |
| Min length | 3 |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| Driver Error | |
|---|---|
| Weather | 5003 |
| Driver/Equip/RD Health | 4546 |
| Driver Distraction | 4230 |
| Road/Vision Obstruction | 2597 |
| Value | Count | Frequency (%) | |
| Driver Error | 152302 | 89.6% | |
| Weather | 5003 | 2.9% | |
| Driver/Equip/RD Health | 4546 | 2.7% | |
| Driver Distraction | 4230 | 2.5% | |
| Road/Vision Obstruction | 2597 | 1.5% | |
| Drug Use | 1345 | 0.8% |
Length
| Max length | 23 |
|---|---|
| Median length | 12 |
| Mean length | 12.40589803 |
| Min length | 7 |
TOTAL_PEOPLE_INVOLVED
Real number (ℝ≥0)
| Distinct count | 19 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.351264240720373 |
|---|---|
| Minimum | 1.0 |
| Maximum | 19.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 19 |
| Range | 18 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.116056721 |
|---|---|
| Coefficient of variation (CV) | 0.4746623974 |
| Kurtosis | 11.08803208 |
| Mean | 2.351264241 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.357585749 |
| Sum | 399769 |
| Variance | 1.245582605 |
| Value | Count | Frequency (%) | |
| 2 | 99045 | 58.3% | |
| 3 | 28360 | 16.7% | |
| 1 | 23022 | 13.5% | |
| 4 | 11161 | 6.6% | |
| 5 | 4776 | 2.8% | |
| 6 | 2100 | 1.2% | |
| 7 | 855 | 0.5% | |
| 8 | 362 | 0.2% | |
| 9 | 156 | 0.1% | |
| 10 | 77 | < 0.1% | |
| Other values (9) | 109 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 23022 | 13.5% | |
| 2 | 99045 | 58.3% | |
| 3 | 28360 | 16.7% | |
| 4 | 11161 | 6.6% | |
| 5 | 4776 | 2.8% |
| Value | Count | Frequency (%) | |
| 19 | 1 | < 0.1% | |
| 18 | 1 | < 0.1% | |
| 17 | 4 | < 0.1% | |
| 16 | 8 | < 0.1% | |
| 15 | 4 | < 0.1% |
DRY_ROAD
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 128493 | 75.6% | |
| 0 | 41530 | 24.4% |
CLEAR_WEATHER
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 135513 | 79.7% | |
| 0 | 34510 | 20.3% |
DRIVER_ERROR
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1 | |
|---|---|
| 0 | 17721 |
| Value | Count | Frequency (%) | |
| 1 | 152302 | 89.6% | |
| 0 | 17721 | 10.4% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | CRASH_RECORD_ID | RD_NO | POSTED_SPEED_LIMIT | TRAFFIC_CONTROL_DEVICE | DEVICE_CONDITION | WEATHER_CONDITION | LIGHTING_CONDITION | FIRST_CRASH_TYPE | TRAFFICWAY_TYPE | ROADWAY_SURFACE_COND | ROAD_DEFECT | REPORT_TYPE | CRASH_TYPE | HIT_AND_RUN_I | DAMAGE | PRIM_CONTRIBUTORY_CAUSE | SEC_CONTRIBUTORY_CAUSE | STREET_NO | STREET_DIRECTION | STREET_NAME | BEAT_OF_OCCURRENCE | NUM_UNITS | INJURIES_TOTAL | INJURIES_FATAL | INJURIES_INCAPACITATING | INJURIES_NON_INCAPACITATING | INJURIES_REPORTED_NOT_EVIDENT | INJURIES_NO_INDICATION | CRASH_HOUR | CRASH_DAY_OF_WEEK | CRASH_MONTH | LATITUDE | LONGITUDE | STREET_TYPE | TRAFFIC_CONTROL_PRESENT | STRAIGHT_ROAD | LEVEL_ROAD | TIME_BEFORE_NOTIFICATION | LANE_TYPE | MAIN_CAUSE | TOTAL_PEOPLE_INVOLVED | DRY_ROAD | CLEAR_WEATHER | DRIVER_ERROR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 6 | 0209e21f298984f7375742b7ef27c9880b485f41123a12b5a8eb14f01171abbbc05974399b985e05a352f801869cae0f41587f39a51994338fb82aeba853eece | JB415436 | 30.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | TURNING | NOT DIVIDED | DRY | UNKNOWN | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | OVER $1,500 | IMPROPER OVERTAKING/PASSING | IMPROPER LANE USAGE | 600.0 | W | DIVISION ST | 1822.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 17.0 | 5.0 | 8.0 | 41.903825 | -87.643286 | ST | 1.0 | 1.0 | 1.0 | 13.0 | NaN | Driver Error | 2.0 | 1 | 1 | 1 |
| 1 | 8 | 02e2ed3606a50dda185f5e97c57a45552087d6fbea1c4b5f3777e0503da72279211f0518aabbeca2cd8e8ee1aca6cae3f88a0531cb62bb39ac156ca3d55e0931 | JB256393 | 25.0 | NO CONTROLS | NO CONTROLS | RAIN | DAYLIGHT | ANGLE | NOT DIVIDED | WET | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | 0.0 | OVER $1,500 | FAILING TO YIELD RIGHT-OF-WAY | UNABLE TO DETERMINE | 9511.0 | S | WENTWORTH AVE | 511.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 11.0 | 4.0 | 5.0 | 41.721290 | -87.628510 | AVE | 0.0 | 1.0 | 1.0 | 5.0 | small | Driver Error | 2.0 | 0 | 0 | 1 |
| 2 | 11 | 046c0f96fdf5f7384e026821bb23fdd56d610dce11247b4cf7072f4e0308cdf5865ee8f31d71792ef005d864c064aae933213ef5e4e87a9bb2247ffe0f56f245 | JC128226 | 30.0 | NO CONTROLS | NO CONTROLS | CLEAR | DARKNESS, LIGHTED ROAD | REAR END | DIVIDED - W/MEDIAN BARRIER | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | OVER $1,500 | EXCEEDING SAFE SPEED FOR CONDITIONS | FOLLOWING TOO CLOSELY | 50.0 | E | GARFIELD BLVD | 225.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 6.0 | 5.0 | 1.0 | 41.794779 | -87.623828 | BLVD | 0.0 | 1.0 | 1.0 | 535.0 | medium | Driver Error | 2.0 | 0 | 1 | 1 |
| 3 | 12 | 04f6245394966ed41b109ac46b18ed45b8b90c6607cebc99008d9a733b4b668d4effab8de602f2ed17854835b5efce5d76701c8d97d25c23c9814ee9e63e7a60 | JB258516 | 30.0 | STOP SIGN/FLASHER | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | REAR END | ONE-WAY | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 1.0 | $501 - $1,500 | IMPROPER BACKING | NOT APPLICABLE | 180.0 | W | SCHILLER ST | 1821.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 18.0 | 5.0 | 5.0 | 41.907777 | -87.634531 | ST | 1.0 | 1.0 | 1.0 | 40.0 | small | Driver Error | 3.0 | 1 | 1 | 1 |
| 4 | 13 | 0564e565ebda939c88d5da6d613ac5789b702cbff5b8744552f9930bd571995afb81a895dfd2bc8a23e6cca53f8fc6a9afbeb38591781281a3c37ceba5cbcbd5 | JC541936 | 20.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | PEDESTRIAN | NOT DIVIDED | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | $500 OR LESS | DISTRACTION - FROM INSIDE VEHICLE | DISTRACTION - FROM INSIDE VEHICLE | 3998.0 | N | ASHLAND AVE | 1922.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 15.0 | 3.0 | 12.0 | 41.954196 | -87.669193 | AVE | 1.0 | 1.0 | 1.0 | 5.0 | NaN | Driver Distraction | 2.0 | 1 | 1 | 0 |
| 5 | 14 | 05a2558531eb0174cb4d8ec5de92fdc94c1894b31923fdbb09f62e41a1eb3716ca641b84c64b6b5dd442cd4f1214eb061318d37154d66d03fb59056987645db7 | JA116988 | 30.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | SIDESWIPE SAME DIRECTION | DIVIDED - W/MEDIAN (NOT RAISED) | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | OVER $1,500 | IMPROPER LANE USAGE | NOT APPLICABLE | 117.0 | W | NORTH AVE | 1821.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4.0 | 14.0 | 1.0 | 1.0 | 41.911051 | -87.632436 | AVE | 0.0 | 1.0 | 1.0 | 20.0 | medium | Driver Error | 4.0 | 1 | 1 | 1 |
| 6 | 15 | 064e66979a2970426924a31edac09282c4ede65aad5827ab5bf314b0c5404ddb82dfd349d1df97f7cdd42fa48054021295a7b5b9f873cf77a8ae5b506516ba24 | JA162887 | 30.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLOUDY/OVERCAST | DAYLIGHT | TURNING | DIVIDED - W/MEDIAN (NOT RAISED) | WET | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | 0.0 | OVER $1,500 | IMPROPER OVERTAKING/PASSING | FAILING TO REDUCE SPEED TO AVOID CRASH | 2101.0 | S | ASHLAND AVE | 1235.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 7.0 | 4.0 | 2.0 | 41.854120 | -87.665902 | AVE | 1.0 | 1.0 | 1.0 | 4.0 | intersection | Driver Error | 3.0 | 0 | 0 | 1 |
| 7 | 18 | 0715747ad03659bf4f8c41699d349d805c0a8863e7033c7f0dd4b6232d2ab96f5c7d161d9f944f4919f1d16520d6f9ebe8fe3d9175212d0f011ee4bf9137b38e | HZ485307 | 30.0 | STOP SIGN/FLASHER | FUNCTIONING PROPERLY | CLEAR | DARKNESS, LIGHTED ROAD | ANGLE | NOT DIVIDED | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | 0.0 | OVER $1,500 | FAILING TO YIELD RIGHT-OF-WAY | DISREGARDING STOP SIGN | 2000.0 | W | ERIE ST | 1221.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 3.0 | 1.0 | 10.0 | 41.893281 | -87.677100 | ST | 1.0 | 1.0 | 1.0 | 3.0 | small | Driver Error | 3.0 | 1 | 1 | 1 |
| 8 | 20 | 07cf8b845534957256f1c0dafd4f95c08037233f3d367db726f9f56686ec31ce7bc3f24e350ae9d93cde2387a6606093775ac87dfb78685050e5ef0f096f67c9 | JB237031 | 30.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | REAR END | NOT DIVIDED | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | OVER $1,500 | FOLLOWING TOO CLOSELY | DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 11.0 | S | AUSTIN BLVD | 1513.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 18.0 | 3.0 | 4.0 | 41.879714 | -87.774496 | BLVD | 1.0 | 1.0 | 1.0 | 800.0 | NaN | Driver Error | 2.0 | 1 | 1 | 1 |
| 9 | 21 | 097eb95ff3e26f44b8ae8f38890128a3ca6158d1cd41f5a3fcb2491b1cac2eb87ad2d281f493e3200223480a6cfbe09e014466bb06428a512ffbd3c84c42d677 | JA454982 | 30.0 | OTHER | NO CONTROLS | CLEAR | DAYLIGHT | SIDESWIPE SAME DIRECTION | NOT DIVIDED | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | OVER $1,500 | IMPROPER LANE USAGE | NOT APPLICABLE | 9505.0 | S | HALSTED ST | 2223.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 8.0 | 2.0 | 10.0 | 41.721256 | -87.643062 | ST | 1.0 | 1.0 | 1.0 | 95.0 | NaN | Driver Error | 2.0 | 1 | 1 | 1 |
Last rows
| df_index | CRASH_RECORD_ID | RD_NO | POSTED_SPEED_LIMIT | TRAFFIC_CONTROL_DEVICE | DEVICE_CONDITION | WEATHER_CONDITION | LIGHTING_CONDITION | FIRST_CRASH_TYPE | TRAFFICWAY_TYPE | ROADWAY_SURFACE_COND | ROAD_DEFECT | REPORT_TYPE | CRASH_TYPE | HIT_AND_RUN_I | DAMAGE | PRIM_CONTRIBUTORY_CAUSE | SEC_CONTRIBUTORY_CAUSE | STREET_NO | STREET_DIRECTION | STREET_NAME | BEAT_OF_OCCURRENCE | NUM_UNITS | INJURIES_TOTAL | INJURIES_FATAL | INJURIES_INCAPACITATING | INJURIES_NON_INCAPACITATING | INJURIES_REPORTED_NOT_EVIDENT | INJURIES_NO_INDICATION | CRASH_HOUR | CRASH_DAY_OF_WEEK | CRASH_MONTH | LATITUDE | LONGITUDE | STREET_TYPE | TRAFFIC_CONTROL_PRESENT | STRAIGHT_ROAD | LEVEL_ROAD | TIME_BEFORE_NOTIFICATION | LANE_TYPE | MAIN_CAUSE | TOTAL_PEOPLE_INVOLVED | DRY_ROAD | CLEAR_WEATHER | DRIVER_ERROR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 170013 | 416170 | 1a3386e6a23e96e01acff8acf0ef1b3e7356197c38e2422162e1d6f75c508a39d017a5d6248b4172c02a935c7e64f540a1e9c2432b67c86e9f795f64f3eff849 | JD236846 | 30.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | TURNING | NOT DIVIDED | WET | UNKNOWN | ON SCENE | NO INJURY / DRIVE AWAY | 1.0 | OVER $1,500 | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 2718.0 | W | FOSTER AVE | 2011.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 16.0 | 3.0 | 5.0 | 41.975941 | -87.697289 | AVE | 0.0 | 1.0 | 1.0 | 10.0 | NaN | Driver Error | 3.0 | 0 | 1 | 1 |
| 170014 | 416172 | 16acabdfcfa055f2e7760b288b67d37c4b2f8564d1eaa1b08abd5de7707e5c56cb5c06fd9034d3492ff2c81bc0ee07bdcff61771b03b2948689c153041c278ac | JD236417 | 25.0 | NO CONTROLS | NO CONTROLS | RAIN | DARKNESS, LIGHTED ROAD | SIDESWIPE SAME DIRECTION | NOT DIVIDED | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 1.0 | $501 - $1,500 | IMPROPER LANE USAGE | NOT APPLICABLE | 7159.0 | S | NORMAL BLVD | 732.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 3.0 | 5.0 | 41.763587 | -87.636913 | BLVD | 0.0 | 1.0 | 1.0 | 570.0 | NaN | Driver Error | 2.0 | 0 | 0 | 1 |
| 170015 | 416173 | 001eecabb8448be837995caca46a221c62245ece1ad580ef77e572be61a030bb614fb67f69f0add17e5e043d4034a88b1cca656c0de307853e7cae281e222a8c | JD236720 | 30.0 | NO CONTROLS | NO CONTROLS | FOG/SMOKE/HAZE | DAYLIGHT | REAR END | NOT DIVIDED | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | $501 - $1,500 | FOLLOWING TOO CLOSELY | FAILING TO REDUCE SPEED TO AVOID CRASH | 2159.0 | N | HARLEM AVE | 2512.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 14.0 | 3.0 | 5.0 | 41.919767 | -87.805972 | AVE | 0.0 | 1.0 | 1.0 | 61.0 | NaN | Driver Error | 2.0 | 0 | 0 | 1 |
| 170016 | 416174 | 0c3ec565fd94621168dccbfd0a95097d0d96ab27241bfee94e818ce7a02c812e70f3ec53d4565670b568ab56ea4a9d6a8d88e18820ec5185f00f004f42147d37 | JD236827 | 30.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | SIDESWIPE SAME DIRECTION | NOT DIVIDED | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | $501 - $1,500 | FOLLOWING TOO CLOSELY | NOT APPLICABLE | 500.0 | S | CENTRAL AVE | 1513.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 16.0 | 3.0 | 5.0 | 41.873773 | -87.764770 | AVE | 0.0 | 1.0 | 1.0 | 20.0 | NaN | Driver Error | 2.0 | 1 | 1 | 1 |
| 170017 | 416182 | ee451349ec959d73cb77c87e2bcfda6bbd378bcd74421660d3c204762dba12bd6a0738c90289e441e6b804060f61a1e4e434a6d62c047308fa3346afc324e2c7 | JD236776 | 25.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | ANGLE | FOUR WAY | WET | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | 1.0 | OVER $1,500 | DISREGARDING TRAFFIC SIGNALS | UNABLE TO DETERMINE | 5032.0 | N | CLARK ST | 2032.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 14.0 | 3.0 | 5.0 | 41.973359 | -87.668224 | ST | 1.0 | 1.0 | 1.0 | 5.0 | NaN | Driver Error | 2.0 | 0 | 1 | 1 |
| 170018 | 416184 | e450bca25335c1278ea2363381ecc508ebd53e5c56674707122b665be54927fd0c49eebe9d98a1f14a95983f1933e726b107399f9436754191e6e1def6e90535 | JD235006 | 30.0 | NO CONTROLS | NO CONTROLS | RAIN | DAWN | PARKED MOTOR VEHICLE | DIVIDED - W/MEDIAN (NOT RAISED) | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | OVER $1,500 | IMPROPER BACKING | NOT APPLICABLE | 3604.0 | N | CENTRAL PARK AVE | 1732.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 13.0 | 1.0 | 5.0 | 41.947062 | -87.717972 | AVE | 0.0 | 1.0 | 1.0 | 52.0 | NaN | Driver Error | 1.0 | 0 | 0 | 1 |
| 170019 | 416185 | d0a818ec05c4314c5f56b82c0590fd98686aeaf01e04756cabb424d171534fbf8adaa91a7560832d82dc0b733466568c498bc900022a3429990bcb190ab51509 | JD235373 | 30.0 | NO CONTROLS | NO CONTROLS | CLEAR | DARKNESS, LIGHTED ROAD | PARKED MOTOR VEHICLE | NOT DIVIDED | DRY | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | 0.0 | OVER $1,500 | DISTRACTION - FROM OUTSIDE VEHICLE | DISTRACTION - FROM OUTSIDE VEHICLE | 6747.0 | W | BELMONT AVE | 2511.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 2.0 | 5.0 | 41.938057 | -87.795161 | AVE | 0.0 | 1.0 | 1.0 | 2.0 | NaN | Driver Distraction | 1.0 | 1 | 1 | 0 |
| 170020 | 416187 | dba8fb67b8cfd7b0d1da3b9f03eccf574edd2835101419c4cbfa728e9d75673d138879354351927fb5fafcd6210bf19c503f66c9e0644a61ece7c333c0bf44ea | JD236770 | 30.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | SIDESWIPE SAME DIRECTION | NOT DIVIDED | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | OVER $1,500 | IMPROPER LANE USAGE | NOT APPLICABLE | 1440.0 | N | ASHLAND AVE | 1433.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 14.0 | 3.0 | 5.0 | 41.908249 | -87.667768 | AVE | 1.0 | 1.0 | 1.0 | 45.0 | NaN | Driver Error | 2.0 | 1 | 1 | 1 |
| 170021 | 416191 | d97477e587b8eecbdb0dbce0a0c5462e7335a4f7da2e04c8e4799193cba69f0b887de56a831e8899031c1f7175e82a2ad8c43ba34260181a3e4e1bafda37ea88 | JD234027 | 40.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | SIDESWIPE SAME DIRECTION | DIVIDED - W/MEDIAN BARRIER | DRY | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | 0.0 | OVER $1,500 | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 120.0 | N | LAKE SHORE DR SB | 114.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 11.0 | 7.0 | 5.0 | 41.883642 | -87.615441 | SB | 0.0 | 0.0 | 1.0 | 10.0 | NaN | Driver Error | 2.0 | 1 | 1 | 1 |
| 170022 | 416193 | de4cbde297443228427759c6d58f40254dc8d8fcb201dc731da85d4d0dcd05fd2fbb10974bc0d17cdecd4128959af5b2fc2a4b8a0ee42f3370be201aba68a5bd | JD235651 | 10.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | REAR TO SIDE | PARKING LOT | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | 0.0 | $500 OR LESS | FAILING TO YIELD RIGHT-OF-WAY | UNABLE TO DETERMINE | 1527.0 | W | LAWRENCE AVE | 1912.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 12.0 | 2.0 | 5.0 | 41.968773 | -87.668624 | AVE | 0.0 | 1.0 | 1.0 | 12.0 | NaN | Driver Error | 2.0 | 1 | 1 | 1 |